﻿/*
This script was created by Visual Studio on 1/11/2010 at 11:38 PM.
Run this script on k0stya-pc.WinterEmpty.dbo to make it the same as k0stya-pc.Winter.dbo.
This script performs its actions in the following order:
1. Disable foreign-key constraints.
2. Perform DELETE commands. 
3. Perform UPDATE commands.
4. Perform INSERT commands.
5. Re-enable foreign-key constraints.
Please back up your target database before running this script.
*/
SET NUMERIC_ROUNDABORT OFF
GO
SET XACT_ABORT, ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
/*Pointer used for text / image updates. This might not be needed, but is declared here just in case*/
DECLARE @pv binary(16)
BEGIN TRANSACTION
ALTER TABLE [dbo].[PersonFriends] DROP CONSTRAINT [FK_PersonFriends_Persons]
ALTER TABLE [dbo].[PersonFriends] DROP CONSTRAINT [FK_PersonFriends_Persons1]
ALTER TABLE [dbo].[Departments] DROP CONSTRAINT [FK_Departments_Faculties]
ALTER TABLE [dbo].[TimeBoard] DROP CONSTRAINT [FK_TimeBoard_Subjects]
ALTER TABLE [dbo].[Faculties] DROP CONSTRAINT [FK_Faculties_Universities]
ALTER TABLE [dbo].[Subjects] DROP CONSTRAINT [FK_Subjects_ParameterValues]
ALTER TABLE [dbo].[TeacherFaculties] DROP CONSTRAINT [FK_TeacherFaculties_Faculties]
ALTER TABLE [dbo].[TeacherFaculties] DROP CONSTRAINT [FK_TeacherFaculties_Teachers]
ALTER TABLE [dbo].[TeacherDepartments] DROP CONSTRAINT [FK_TeacherDepartments_Departments]
ALTER TABLE [dbo].[TeacherDepartments] DROP CONSTRAINT [FK_TeacherDepartments_Teachers]
ALTER TABLE [dbo].[Groups] DROP CONSTRAINT [FK_Groups_Departments]
ALTER TABLE [dbo].[TheacherSubjects] DROP CONSTRAINT [FK_TheacherSubjects_Subjects]
ALTER TABLE [dbo].[TheacherSubjects] DROP CONSTRAINT [FK_TheacherSubjects_Teachers]
ALTER TABLE [dbo].[Teachers] DROP CONSTRAINT [FK_Teachers_Persons]
ALTER TABLE [meta].[Localizations] DROP CONSTRAINT [FK_Localizations_Languages]
ALTER TABLE [meta].[Localizations] DROP CONSTRAINT [FK_Localizations_Resources]
ALTER TABLE [dbo].[PersonSchedules] DROP CONSTRAINT [FK_PersonSchedules_Persons]
ALTER TABLE [dbo].[PersonSchedules] DROP CONSTRAINT [FK_PersonSchedules_Schedules]
ALTER TABLE [dbo].[Students] DROP CONSTRAINT [FK_Students_Groups]
ALTER TABLE [dbo].[Students] DROP CONSTRAINT [FK_Students_Persons]
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__37A5467C]
ALTER TABLE [dbo].[Persons] DROP CONSTRAINT [FK_Persons_aspnet_Users]
ALTER TABLE [dbo].[Persons] DROP CONSTRAINT [FK_Persons_ParameterValues]
ALTER TABLE [meta].[ParameterValues] DROP CONSTRAINT [FK_ParameterValues_Parameters]
ALTER TABLE [meta].[ParameterValues] DROP CONSTRAINT [FK_ParameterValues_Resources]
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__36B12243]
ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__49C3F6B7]
ALTER TABLE [meta].[Parameters] DROP CONSTRAINT [FK_Parameters_Resources]
ALTER TABLE [dbo].[Events] DROP CONSTRAINT [FK_Classes_Persons]
ALTER TABLE [dbo].[Events] DROP CONSTRAINT [FK_Classes_Subjects]
ALTER TABLE [dbo].[Events] DROP CONSTRAINT [FK_Events_Builgings]
ALTER TABLE [dbo].[Events] DROP CONSTRAINT [FK_Events_EventTypes]
ALTER TABLE [dbo].[Events] DROP CONSTRAINT [FK_Events_Schedules]
ALTER TABLE [dbo].[GroupSchedules] DROP CONSTRAINT [FK_GroupSchedules_Groups]
ALTER TABLE [dbo].[GroupSchedules] DROP CONSTRAINT [FK_GroupSchedules_Schedules]
ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__3B75D760]
ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__5165187F]
ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT [FK__aspnet_Pr__UserI__3A81B327]
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__34C8D9D1]
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__45F365D3]
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__35BCFE0A]
ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__46E78A0C]
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__3E52440B]
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__5535A963]
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__3D5E1FD2]
ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__5441852A]
ALTER TABLE [dbo].[PersonMessages] DROP CONSTRAINT [FK_PersonMessages_Message]
ALTER TABLE [dbo].[PersonMessages] DROP CONSTRAINT [FK_PersonMessages_Persons]
ALTER TABLE [dbo].[Message] DROP CONSTRAINT [FK_Message_Persons]
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__38996AB5]
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__4CA06362]
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__398D8EEE]
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__4D94879B]
ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [FK__aspnet_Us__Appli__3C69FB99]
INSERT INTO [dbo].[aspnet_Applications] ([ApplicationId], [ApplicationName], [LoweredApplicationName], [Description]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'Winter.BackEnd', N'winter.backend', NULL)
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'admin', N'2107f78b-005a-44bc-9ca6-53af799d6cb4', N'Admin', NULL, 0, '20091119 13:11:18.657')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'anonymous', N'f011d25d-79e9-40ff-9480-1d4c35674913', N'Anonymous', NULL, 0, '20091105 12:28:31.787')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'bazurin', N'fcc17ccd-3566-42a1-8cda-17ec63764215', N'bazurin', NULL, 0, '20100110 20:59:45.523')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'classmonitor', N'f21c42f1-27be-482b-b46a-c2d6cabffa84', N'ClassMonitor', NULL, 0, '20091105 12:28:03.250')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'lina', N'edc890d7-5cf8-4a59-9520-b3019f459d76', N'lina', NULL, 0, '20100111 18:51:35.887')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'luda', N'053735dc-1ef7-4eae-9d0a-feec9001175a', N'luda', NULL, 0, '20100111 19:01:18.857')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'mainteacher', N'8d317d33-6d05-422b-921f-f43c8b4bb87b', N'MainTeacher', NULL, 0, '20091105 12:27:13.227')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'shadow', N'29b8cbc9-2495-485f-8ecd-cad42c8ac04a', N'shadow', NULL, 0, '20100110 18:06:42.827')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'student', N'7b4d1c7a-3ea1-48b2-a361-2ad85a314224', N'student', NULL, 0, '20100111 19:47:14.617')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'tanya', N'0284809c-73a9-45c0-9660-f3f1286ed461', N'tanya', NULL, 0, '20091119 13:23:20.003')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'test', N'd9958909-d978-4009-a0d7-d2993053436b', N'test', NULL, 0, '20091115 17:10:01.930')
INSERT INTO [dbo].[aspnet_Users] ([ApplicationId], [LoweredUserName], [UserId], [UserName], [MobileAlias], [IsAnonymous], [LastActivityDate]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'testteacher', N'081b7397-2bb8-4965-93c0-77335b68ce0c', N'TestTeacher', NULL, 0, '20091105 12:27:38.617')
SET IDENTITY_INSERT [dbo].[Message] ON
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (1, N'asdfdasf', N'asdfdasf', '20091213 13:03:19.840', 1, 1, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (2, N'asdfdasf dsaf sdf', N'asdfdasf', '20091213 13:03:25.143', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (3, N'sadfsdf', N'asdfasdf', '20091213 16:08:25.113', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (4, N'asdfasdf', N'asdfsadf', '20091213 16:08:55.490', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (5, N'adsfasdf', N'dsfdsaf', '20091213 16:20:20.660', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (6, N'sdfsdf', N'asdfsadf', '20091213 16:20:41.973', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (7, N'dasfadsf', N'adsfasdf', '20091213 16:21:53.493', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (8, N'123123', N'13213', '20091213 16:22:02.777', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (9, N'dfasdf', N'asdfs', '20091213 16:22:58.133', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (10, N'asdfasdf', N'asdfdasf', '20091213 16:24:04.543', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (26, N'asdfasdf2234', N'asdfsadf1342', '20091213 16:28:54.367', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (27, N'asdfasdf', N'sdfsaf', '20091213 16:31:41.377', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (28, N'sdafs', N'sfasdf', '20091213 16:31:57.723', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (29, N'asdfsadf', N'safsadf', '20091213 16:53:11.953', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (30, N'asdfsdaf', N'asdf', '20091213 16:55:58.710', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (31, N'12312312', N'123123', '20091213 16:56:08.887', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (32, N'123123', N'123123', '20091213 16:56:24.703', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (33, N'123123', N'123123', '20091213 16:56:54.397', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (34, N'asdf', N'dasf', '20091213 17:10:31.047', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (35, N'asdf', N'dasf', '20091213 17:10:49.433', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (36, N'asdf', N'dasf', '20091213 17:11:00.163', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (37, N'fasd', N'asdfas', '20091213 17:12:39.383', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (38, N'fasd', N'asdfas', '20091213 17:12:44.793', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (39, N'fasd2', N'asdfas2', '20091213 17:12:50.617', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (40, N's', N'sd', '20091213 17:13:30.430', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (41, N's', N's', '20091213 17:14:50.823', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (42, N'ss', N'ss', '20091213 17:15:05.350', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (44, N'sdfa', N'asdf', '20091213 17:57:00.040', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (45, N'asdf', N'ddsaf', '20091213 18:07:23.093', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (46, N'asdf', N'ddsaf', '20091213 18:07:40.080', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (47, N'asdf', N'asdf', '20091214 00:33:18.570', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (48, N'sadfsdf', N'asdf', '20091214 00:55:51.393', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (49, N'asdkf;jasdf
asdfas
f dasf jkdasf js''daf
\sdf', N'123123 123 123 123', '20091214 00:57:30.203', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (50, N'asdkf;jasdf
asdfas
f dasf jkdasf js''daf
\sdf', N'123123 123 123 123', '20091214 00:57:35.083', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (51, N'
asd
f
asd
f
sad
f
as
df
a
sdf

asd
f
asd
f
asdf

asd
f
asd
f
asd
f
ads
f
sd
f

sdf
ds
f
sd
f
sd
f
sdf

sf



fff', N'sda fasdf    ', '20091214 00:58:15.223', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (52, N's', N's', '20091214 00:58:29.903', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (53, N'1', N'1', '20091214 00:58:58.713', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (54, N'1', N'1', '20091214 00:59:13.403', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (55, N'2', N'2', '20091214 00:59:20.673', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (56, N'asdf', N'asdf', '20091214 01:18:51.427', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (57, N'asdf', N'asdf', '20091214 01:22:51.057', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (58, N'asdf', N'asdf', '20091214 01:23:03.480', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (59, N'фывафыва а
фыв
а
фыв
а
фыв
а
вфы
а
фы
ва
вфы
а
', N'as fasdf sdaf asdf dasf dasf', '20100106 00:00:55.337', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (66, N'фывафыва а
фыв
а
фыв
а
фыв
а
вфы
а
фы
ваasdf


а
', N'as fasdf sdaf asdf dasf dasf', '20100106 00:01:43.457', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (67, N'фывафыва а
фыв
а
фыв
а
фыв
а
вфы
а
фы
ваasdf


а
', N'as fasdf sdaf asdf dasf dasf', '20100106 00:01:46.020', 1, 1, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (68, N'Проверка работоспособности...', N'От Пети', '20100109 16:43:40.517', 9, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (69, N'Національний технічний університет України

"Київський політехнічний інститут" ', N'test', '20100109 16:52:19.987', 9, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (70, N'123', N'123', '20100109 19:06:05.130', 1, 0, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (71, N's', N'asd', '20100109 19:08:56.117', 1, 0, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (72, N'asd', N'asd', '20100110 15:11:25.147', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (73, N'123', N'123', '20100110 18:00:09.517', 1, 1, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (74, N'sdf', N'adsf', '20100111 00:10:21.360', 1, 0, 0)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (75, N'sd', N'sd', '20100111 00:14:28.980', 1, 0, 1)
INSERT INTO [dbo].[Message] ([ID], [Body], [Subject], [SendTime], [SenderID], [IsDeleted], [IsNew]) VALUES (76, N'1', N'1', '20100111 20:51:35.227', 5, 0, 1)
SET IDENTITY_INSERT [dbo].[Message] OFF
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 1)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 2)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 3)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 4)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 5)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 6)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 7)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 8)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 9)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 10)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 26)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 27)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 28)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 29)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 30)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 31)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 32)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 33)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 34)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 35)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 36)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 37)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 38)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 39)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 40)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 41)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 42)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 44)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 45)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 46)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 47)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 48)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 49)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 50)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 51)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 52)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 53)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 54)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 55)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 56)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 57)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 58)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 59)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 66)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 67)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 68)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 69)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 72)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 73)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 74)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (1, 75)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (6, 76)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (9, 70)
INSERT INTO [dbo].[PersonMessages] ([PersonID], [MessageID]) VALUES (9, 71)
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'0284809c-73a9-45c0-9660-f3f1286ed461', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'053735dc-1ef7-4eae-9d0a-feec9001175a', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'081b7397-2bb8-4965-93c0-77335b68ce0c', N'822565fe-deb3-413e-879f-4144569835d8')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'2107f78b-005a-44bc-9ca6-53af799d6cb4', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'29b8cbc9-2495-485f-8ecd-cad42c8ac04a', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'7b4d1c7a-3ea1-48b2-a361-2ad85a314224', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'8d317d33-6d05-422b-921f-f43c8b4bb87b', N'822565fe-deb3-413e-879f-4144569835d8')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'd9958909-d978-4009-a0d7-d2993053436b', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'edc890d7-5cf8-4a59-9520-b3019f459d76', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'f011d25d-79e9-40ff-9480-1d4c35674913', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_UsersInRoles] ([UserId], [RoleId]) VALUES (N'fcc17ccd-3566-42a1-8cda-17ec63764215', N'8c8e85bf-b885-4b1d-8a99-057a480851c9')
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'0284809c-73a9-45c0-9660-f3f1286ed461', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'Khi+XyKJQ6wg3XIJOcdrFg2Rdpc=', 1, N'x6cEJsIBK7Q+GU3lZExcDg==', NULL, N'tanya@kpi.com', N'tanya@kpi.com', NULL, NULL, 1, 0, '20091119 13:13:05.000', '20091119 13:21:44.530', '20091119 13:13:05.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'053735dc-1ef7-4eae-9d0a-feec9001175a', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'B7IJuA3j+QpXSDaHsZot2nhViKc=', 1, N'E+jvBrZUyvunZ+7LFstSNQ==', NULL, N'luda@kpi.com', N'luda@kpi.com', NULL, NULL, 1, 0, '20091119 13:14:17.000', '20100111 18:51:48.080', '20091119 13:14:17.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'081b7397-2bb8-4965-93c0-77335b68ce0c', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N's2timqwxmJEjjUNIpcJ35kfh3Jw=', 1, N'ALumF0gmsGkILDgn7qkrpA==', NULL, N'TestTeacher@winter.com', N'testteacher@winter.com', NULL, NULL, 1, 0, '20091105 12:27:38.000', '20091105 12:27:38.617', '20091105 12:27:38.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'2107f78b-005a-44bc-9ca6-53af799d6cb4', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'uYre7fvnYgxLrIfgR92gTFHFE0k=', 1, N'SdhP4z0CBD1uDVS+kaYnsA==', NULL, N'hkostya@gmail.com', N'hkostya@gmail.com', NULL, NULL, 1, 0, '20091001 21:05:21.000', '20091119 12:47:02.127', '20091001 21:05:21.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'29b8cbc9-2495-485f-8ecd-cad42c8ac04a', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'kt8aOcpsza6J+PY+HEwS19ZPlOk=', 1, N'VXs5VWpk43u5lac7XFDsnw==', NULL, N'sasha@kpi.com', N'sasha@kpi.com', NULL, NULL, 1, 0, '20091119 13:15:32.000', '20100110 17:58:53.160', '20091119 13:15:32.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'7b4d1c7a-3ea1-48b2-a361-2ad85a314224', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'kD06mC17uv4657/Vf0v9QFTQIYA=', 1, N'ZOtcCq38xzjd5PtWkpW62w==', NULL, N'kos@2.2', N'kos@2.2', NULL, NULL, 1, 0, '20091025 17:27:27.000', '20100111 19:44:40.993', '20091025 17:27:27.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'8d317d33-6d05-422b-921f-f43c8b4bb87b', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'z9SYWYqEaVtFA2A4mXdfedW+T0Q=', 1, N'v5us8FkdWC/Ie7DSqqQvXw==', NULL, N'MainTeacher@winter.com', N'mainteacher@winter.com', NULL, NULL, 1, 0, '20091105 12:27:12.000', '20091105 12:27:13.227', '20091105 12:27:12.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'd9958909-d978-4009-a0d7-d2993053436b', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'POZXN4Z+v4O1pMVssVE4o2EhBFU=', 1, N'UG7SouWNWC/CRVfxBfmY4A==', NULL, N'Student@winter.com', N'student@winter.com', NULL, NULL, 1, 0, '20091105 12:28:51.000', '20091114 21:05:13.970', '20091105 12:28:51.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'edc890d7-5cf8-4a59-9520-b3019f459d76', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'v0yKPWFaH9W3Gp2ef2w+IZ4YGuU=', 1, N'FqUv5pLYp8cokkP9JlgMEg==', NULL, N'lina@kpi.com', N'lina@kpi.com', NULL, NULL, 1, 0, '20091119 13:15:05.000', '20100111 18:44:28.927', '20091119 13:15:05.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'f011d25d-79e9-40ff-9480-1d4c35674913', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'UCInV4H/9yx1LdfuiP4umD3o4VE=', 1, N'quuAElOwrcruMzez/K0AIQ==', NULL, N'Anonymous@winter.com', N'anonymous@winter.com', NULL, NULL, 1, 0, '20091105 12:28:31.000', '20091105 12:28:31.787', '20091105 12:28:31.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'f21c42f1-27be-482b-b46a-c2d6cabffa84', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'as+l0bdnH9SmN3UrFal+2iljt+k=', 1, N'7ljh9+cTCMfcZkwccLkpcA==', NULL, N'ClassMonitor@winter.com', N'classmonitor@winter.com', NULL, NULL, 1, 0, '20091105 12:28:03.000', '20091105 12:28:03.250', '20091105 12:28:03.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Membership] ([UserId], [ApplicationId], [Password], [PasswordFormat], [PasswordSalt], [MobilePIN], [Email], [LoweredEmail], [PasswordQuestion], [PasswordAnswer], [IsApproved], [IsLockedOut], [CreateDate], [LastLoginDate], [LastPasswordChangedDate], [LastLockoutDate], [FailedPasswordAttemptCount], [FailedPasswordAttemptWindowStart], [FailedPasswordAnswerAttemptCount], [FailedPasswordAnswerAttemptWindowStart], [Comment]) VALUES (N'fcc17ccd-3566-42a1-8cda-17ec63764215', N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'kla20XV7ldUlkVovo0gAP2WCIN0=', 1, N'gFMVfgRfanbrMBRgfDS2Hw==', NULL, N'b@b.2', N'b@b.2', NULL, NULL, 1, 0, '20091114 15:04:11.000', '20100110 16:53:08.320', '20091114 15:04:11.000', '17540101 00:00:00.000', 0, '17540101 00:00:00.000', 0, '17540101 00:00:00.000', NULL)
INSERT INTO [dbo].[aspnet_Roles] ([ApplicationId], [LoweredRoleName], [RoleId], [RoleName], [Description]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'admin', N'4e92cadd-355e-472f-97a2-c2132b942be8', N'Admin', NULL)
INSERT INTO [dbo].[aspnet_Roles] ([ApplicationId], [LoweredRoleName], [RoleId], [RoleName], [Description]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'anonymous', N'df5e253c-7c76-4af2-b341-05ac089b989f', N'Anonymous', NULL)
INSERT INTO [dbo].[aspnet_Roles] ([ApplicationId], [LoweredRoleName], [RoleId], [RoleName], [Description]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'classmonitor', N'34ab794b-fcec-49bc-9144-001a8430a8a4', N'ClassMonitor', NULL)
INSERT INTO [dbo].[aspnet_Roles] ([ApplicationId], [LoweredRoleName], [RoleId], [RoleName], [Description]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'student', N'8c8e85bf-b885-4b1d-8a99-057a480851c9', N'Student', NULL)
INSERT INTO [dbo].[aspnet_Roles] ([ApplicationId], [LoweredRoleName], [RoleId], [RoleName], [Description]) VALUES (N'b623aad3-cdda-4a16-9581-53dc26c13b03', N'teacher', N'822565fe-deb3-413e-879f-4144569835d8', N'Teacher', NULL)
SET IDENTITY_INSERT [dbo].[Schedules] ON
INSERT INTO [dbo].[Schedules] ([ID], [Year]) VALUES (1, '20090101 00:00:00.000')
SET IDENTITY_INSERT [dbo].[Schedules] OFF
INSERT INTO [dbo].[GroupSchedules] ([GroupID], [ScheduleID]) VALUES (1, 1)
SET IDENTITY_INSERT [dbo].[Events] ON
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (25, NULL, '20091207 00:00:00.000', '99991231 23:59:59.997', NULL, 1, NULL, 1, 0, N'New event', 1, N'week_1___0,1,2,3,4,5#no', 300, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (26, NULL, '20091210 00:40:00.000', '20091210 04:15:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (27, NULL, '20091210 01:00:00.000', '20091210 03:50:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (28, NULL, '20091208 00:55:00.000', '20091208 03:35:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (29, NULL, '20091217 00:55:00.000', '20091217 04:25:00.000', NULL, 1, NULL, 1, 0, N'some test here', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (30, NULL, '20091216 04:40:00.000', '20091216 06:00:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (31, NULL, '20091215 04:40:00.000', '20091215 16:55:00.000', NULL, 1, NULL, 1, 0, N'asdfdsf', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (32, NULL, '20091217 05:15:00.000', '20091217 10:35:00.000', NULL, 1, NULL, 1, 0, N'asdfasdf
safasdfas', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (33, NULL, '20091229 01:30:00.000', '20091229 01:35:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (34, NULL, '20100106 02:20:00.000', '20100106 02:25:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (35, NULL, '20100107 01:50:00.000', '20100107 01:55:00.000', NULL, 1, NULL, 1, 0, N'New event', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (36, NULL, '20100109 01:05:00.000', '20100109 09:40:00.000', NULL, 1, NULL, 1, 0, N'some text here about current event ', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (37, NULL, '20100108 03:30:00.000', '20100108 05:20:00.000', NULL, 1, NULL, 1, 0, N'В.М.', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (38, NULL, '20100108 03:30:00.000', '20100108 05:20:00.000', NULL, 1, NULL, 1, 0, N'В.М.', 1, NULL, 1262914200, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (39, 3, '20100112 03:30:00.000', '20100112 05:20:00.000', N'100', 1, 1, 1, 1, N'В.М.', 1, NULL, 1262914200, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (40, 4, '20100113 03:30:00.000', '20100113 05:20:00.000', N'100', 1, 1, 1, 1, N'В.М.', 1, NULL, 1262914200, NULL)
INSERT INTO [dbo].[Events] ([ID], [SubjectID], [EventStartTime], [EventEndTime], [LetureRoom], [PersonID], [BuildingID], [EventTypeID], [IsClass], [Description], [ScheduleID], [rec_type], [event_length], [event_pid]) VALUES (41, 4, '20100111 03:30:00.000', '20100111 05:20:00.000', N'100', 1, 1, 1, 1, N'В.М.', 1, NULL, 1262914200, NULL)
SET IDENTITY_INSERT [dbo].[Events] OFF
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'EconomyScience')
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'Female')
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'Male')
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'NaturalScience')
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'ProffesionalScience')
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'Sex')
INSERT INTO [meta].[Resources] ([Name]) VALUES (N'SubjectType')
SET IDENTITY_INSERT [meta].[Parameters] ON
INSERT INTO [meta].[Parameters] ([Name], [ID]) VALUES (N'Sex', 1)
INSERT INTO [meta].[Parameters] ([Name], [ID]) VALUES (N'SubjectType', 5)
SET IDENTITY_INSERT [meta].[Parameters] OFF
SET IDENTITY_INSERT [meta].[ParameterValues] ON
INSERT INTO [meta].[ParameterValues] ([ID], [Value], [ParameterID]) VALUES (1, N'Male', 1)
INSERT INTO [meta].[ParameterValues] ([ID], [Value], [ParameterID]) VALUES (2, N'Female', 1)
INSERT INTO [meta].[ParameterValues] ([ID], [Value], [ParameterID]) VALUES (3, N'NaturalScience', 5)
INSERT INTO [meta].[ParameterValues] ([ID], [Value], [ParameterID]) VALUES (4, N'EconomyScience', 5)
INSERT INTO [meta].[ParameterValues] ([ID], [Value], [ParameterID]) VALUES (5, N'ProffesionalScience', 5)
SET IDENTITY_INSERT [meta].[ParameterValues] OFF
SET IDENTITY_INSERT [dbo].[Persons] ON
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (1, N'7b4d1c7a-3ea1-48b2-a361-2ad85a314224', N'Іван', N'Петрович', N'Сидоренко', '19991003 00:00:00.000', 1, N'0441312123', N'sh.jpg', NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (2, NULL, N'Олена', N'Василівна', N'Костенко', '19921010 00:00:00.000', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (3, NULL, N'Іван', N'Миколайович', N'Петрушин', '19921010 00:00:00.000', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (4, N'29b8cbc9-2495-485f-8ecd-cad42c8ac04a', N'Микола', N'Анатолійович', N'Дзюба', '19921010 00:00:00.000', 1, N'0441312121', NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (5, N'edc890d7-5cf8-4a59-9520-b3019f459d76', N'Галина', N'Петрівна', N'Кучма', '19921010 00:00:00.000', 1, N'0441312143', N'student.jpg', NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (6, N'053735dc-1ef7-4eae-9d0a-feec9001175a', N'Людмила', N'Костянтинівна', N'Гора', '19921010 00:00:00.000', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (7, N'0284809c-73a9-45c0-9660-f3f1286ed461', N'Татяна', N'Генадіївна', N'Коломийко', '19130113 00:00:00.000', 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (8, NULL, N'_', N'_', N'_', NULL, 1, NULL, NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (9, N'fcc17ccd-3566-42a1-8cda-17ec63764215', N'Петя', N'Петрович', N'Базурин', '19921010 00:00:00.000', 1, N'80688888888', NULL, 1)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (14, NULL, N'Таня', N'В', N'Линник', '19991010 00:00:00.000', 2, N'80688888888', NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (15, NULL, N'Люда', N'С', N'Люда', '19991010 00:00:00.000', 2, N'80688888888', NULL, NULL)
INSERT INTO [dbo].[Persons] ([ID], [aspnet_UserID], [FirstName], [SecondName], [LastName], [Birthdate], [SexID], [Phone], [ImageName], [IsClassMonitor]) VALUES (17, NULL, N'Лина', N'С', N'Дунаевска', '19991010 00:00:00.000', 2, N'80688888888', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Persons] OFF
SET IDENTITY_INSERT [dbo].[Students] ON
INSERT INTO [dbo].[Students] ([ID], [GroupID], [PersonID]) VALUES (1, 1, 1)
INSERT INTO [dbo].[Students] ([ID], [GroupID], [PersonID]) VALUES (4, 1, 6)
INSERT INTO [dbo].[Students] ([ID], [GroupID], [PersonID]) VALUES (5, 1, 9)
INSERT INTO [dbo].[Students] ([ID], [GroupID], [PersonID]) VALUES (6, 1, 4)
INSERT INTO [dbo].[Students] ([ID], [GroupID], [PersonID]) VALUES (8, 1, 5)
INSERT INTO [dbo].[Students] ([ID], [GroupID], [PersonID]) VALUES (9, 1, 7)
SET IDENTITY_INSERT [dbo].[Students] OFF
INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'common', N'1', 1)
INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'health monitoring', N'1', 1)
INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'membership', N'1', 1)
INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'personalization', N'1', 1)
INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'profile', N'1', 1)
INSERT INTO [dbo].[aspnet_SchemaVersions] ([Feature], [CompatibleSchemaVersion], [IsCurrentVersion]) VALUES (N'role manager', N'1', 1)
INSERT INTO [meta].[Languages] ([Name]) VALUES (N'en-US')
INSERT INTO [meta].[Languages] ([Name]) VALUES (N'uk-UA')
SET IDENTITY_INSERT [meta].[Localizations] ON
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'EconomyScience', N'en-US', 7, N'Economy science')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'EconomyScience', N'uk-UA', 5, N'Соціально-економічна підготовка')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'Female', N'en-US', 2, N'Female')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'Female', N'uk-UA', 10, N'Жінка')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'Male', N'en-US', 1, N'Male')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'Male', N'uk-UA', 9, N'Чоловік')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'NaturalScience', N'en-US', 3, N'Natural science')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'NaturalScience', N'uk-UA', 4, N'Природничо-наукова підготовка')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'ProffesionalScience', N'en-US', 8, N'Proffesional science')
INSERT INTO [meta].[Localizations] ([Resource], [LanguageName], [ID], [Text]) VALUES (N'ProffesionalScience', N'uk-UA', 6, N'Професійна та практична підготовка')
SET IDENTITY_INSERT [meta].[Localizations] OFF
SET IDENTITY_INSERT [dbo].[Teachers] ON
INSERT INTO [dbo].[Teachers] ([ID], [TeacherDepartmentsID], [TeacherFacultiesID], [PersonID]) VALUES (1, NULL, 2, 2)
INSERT INTO [dbo].[Teachers] ([ID], [TeacherDepartmentsID], [TeacherFacultiesID], [PersonID]) VALUES (2, NULL, 2, 3)
INSERT INTO [dbo].[Teachers] ([ID], [TeacherDepartmentsID], [TeacherFacultiesID], [PersonID]) VALUES (3, NULL, 2, 4)
INSERT INTO [dbo].[Teachers] ([ID], [TeacherDepartmentsID], [TeacherFacultiesID], [PersonID]) VALUES (4, NULL, 2, 5)
SET IDENTITY_INSERT [dbo].[Teachers] OFF
INSERT INTO [dbo].[TheacherSubjects] ([TeacherID], [SubjectID]) VALUES (1, 3)
INSERT INTO [dbo].[TheacherSubjects] ([TeacherID], [SubjectID]) VALUES (2, 4)
SET IDENTITY_INSERT [dbo].[Groups] ON
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (1, N'РФ-61', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (2, N'РФ-62', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (3, N'РФ-63', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (5, N'ИО-61', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (7, N'ИО-62', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (8, N'ИО-63', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (9, N'ИК-51', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (11, N'ИК-52', 1)
INSERT INTO [dbo].[Groups] ([ID], [Name], [DepartmentID]) VALUES (12, N'ИК-53', 1)
SET IDENTITY_INSERT [dbo].[Groups] OFF
SET IDENTITY_INSERT [dbo].[Subjects] ON
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (3, 3, N'Дискретна математика')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (4, 3, N'Теория автоматизации и управления')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (5, 3, N'Защита информации')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (6, 3, N'Компьютерная графика')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (7, 3, N'В.М.')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (8, 4, N'Иностранный язык')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (9, 4, N'Философия')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (10, 4, N'Психология')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (11, 4, N'Социология')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (12, 4, N'Экономика')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (13, 4, N'Правоведение')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (14, 4, N'Экономика та организация предприятия')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (15, 3, N'Загальна фізика')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (16, 3, N'Хімія та електрорадіоматеріали')
INSERT INTO [dbo].[Subjects] ([ID], [SubjectType], [Name]) VALUES (17, 3, N'Інженерна та компютерна графіка')
SET IDENTITY_INSERT [dbo].[Subjects] OFF
SET IDENTITY_INSERT [dbo].[Faculties] ON
INSERT INTO [dbo].[Faculties] ([ID], [Name], [UniversityID]) VALUES (2, N'РТФ', 1)
INSERT INTO [dbo].[Faculties] ([ID], [Name], [UniversityID]) VALUES (3, N'ИПСА', 1)
INSERT INTO [dbo].[Faculties] ([ID], [Name], [UniversityID]) VALUES (5, N'ФПМ', 1)
INSERT INTO [dbo].[Faculties] ([ID], [Name], [UniversityID]) VALUES (6, N'ФЕЛ', 1)
INSERT INTO [dbo].[Faculties] ([ID], [Name], [UniversityID]) VALUES (7, N'ФІОТ', 1)
INSERT INTO [dbo].[Faculties] ([ID], [Name], [UniversityID]) VALUES (8, N'ФММ', 1)
SET IDENTITY_INSERT [dbo].[Faculties] OFF
SET IDENTITY_INSERT [dbo].[TimeBoard] ON
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (1, 8, N'НГ-01', 14.00, 0, 252, 0, 252, N'', N'2,4,6,7', NULL, NULL, 2.00, 2.00, 2.00, 2.00, 2.00, 2.00, 2.00, 2.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (6, 9, N'НГ-02', 3.00, 46, 18, 0, 54, N'', N'4', NULL, NULL, 0.00, 0.00, 0.00, 3.00, 0.00, 0.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (7, 10, N'НГ-03', 2.00, 18, 18, 0, 36, N'', N'5', NULL, NULL, 0.00, 0.00, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (9, 11, N'НГ-04', 2.00, 18, 18, 0, 36, N'', N'5', NULL, NULL, 0.00, 0.00, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (10, 12, N'НГ-05', 3.00, 36, 18, 0, 36, N'', N'6', NULL, NULL, 0.00, 0.00, 0.00, 0.00, 0.00, 3.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (12, 7, N'НФ-01', 23.00, 198, 162, 0, 468, N'1,2,3', NULL, NULL, NULL, 7.00, 7.00, 5.00, 0.00, 0.00, 0.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (13, 15, N'НФ-02', 12.00, 72, 72, 36, 252, N'1,2', NULL, NULL, NULL, 5.00, 5.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (17, 16, N'НФ-03', 3.00, 54, 36, 0, 54, N'', N'1', NULL, NULL, 3.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00)
INSERT INTO [dbo].[TimeBoard] ([ID], [SubjectID], [SubjectCode], [CreditsECTS], [Lectures], [Practices], [LaboratoryWork], [IndependentStudentWork], [ExamsOrder], [TestsOrder], [DirectionalProjectOrder], [DirectionalWorkOrder], [FirstTerm], [SecondTerm], [ThirdTerm], [FourthTerm], [FifthTerm], [SixthTerm], [SeventhTerm], [EighthTerm]) VALUES (19, 17, N'НФ-04', 6.00, 72, 18, 18, 108, N'2', NULL, NULL, NULL, 0.00, 4.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00)
SET IDENTITY_INSERT [dbo].[TimeBoard] OFF
SET IDENTITY_INSERT [dbo].[Departments] ON
INSERT INTO [dbo].[Departments] ([ID], [Name], [FacultyID]) VALUES (1, N'TK', 2)
INSERT INTO [dbo].[Departments] ([ID], [Name], [FacultyID]) VALUES (2, N'АСОИУ', 2)
INSERT INTO [dbo].[Departments] ([ID], [Name], [FacultyID]) VALUES (3, N'ВТ', 2)
INSERT INTO [dbo].[Departments] ([ID], [Name], [FacultyID]) VALUES (4, N'АУТС', 2)
SET IDENTITY_INSERT [dbo].[Departments] OFF
SET IDENTITY_INSERT [dbo].[Builgings] ON
INSERT INTO [dbo].[Builgings] ([ID], [BuildingName], [Latitude], [Longitude], [Location]) VALUES (1, N'K1', N'50.449297', N'30.460728', N'Peremogy Ave, Київ, Ukraine')
SET IDENTITY_INSERT [dbo].[Builgings] OFF
SET IDENTITY_INSERT [dbo].[Universities] ON
INSERT INTO [dbo].[Universities] ([ID], [Name]) VALUES (1, N'KPI')
SET IDENTITY_INSERT [dbo].[Universities] OFF
SET IDENTITY_INSERT [dbo].[EventTypes] ON
INSERT INTO [dbo].[EventTypes] ([ID], [EventType]) VALUES (1, N'Class')
SET IDENTITY_INSERT [dbo].[EventTypes] OFF
SET IDENTITY_INSERT [dbo].[PersonFriends] ON
INSERT INTO [dbo].[PersonFriends] ([ID], [PersonID], [FriendID]) VALUES (1, 1, 9)
INSERT INTO [dbo].[PersonFriends] ([ID], [PersonID], [FriendID]) VALUES (2, 5, 1)
INSERT INTO [dbo].[PersonFriends] ([ID], [PersonID], [FriendID]) VALUES (3, 5, 6)
INSERT INTO [dbo].[PersonFriends] ([ID], [PersonID], [FriendID]) VALUES (4, 6, 1)
SET IDENTITY_INSERT [dbo].[PersonFriends] OFF
SET IDENTITY_INSERT [dbo].[DayOfWeek] ON
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (1, N'Sunday')
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (2, N'Monday')
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (3, N'Tuesday')
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (4, N'Wednesday')
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (5, N'Thursday')
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (6, N'Friday')
INSERT INTO [dbo].[DayOfWeek] ([ID], [DayOfWeekName]) VALUES (7, N'Saturday')
SET IDENTITY_INSERT [dbo].[DayOfWeek] OFF
ALTER TABLE [dbo].[PersonFriends] ADD CONSTRAINT [FK_PersonFriends_Persons] FOREIGN KEY ([PersonID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[PersonFriends] ADD CONSTRAINT [FK_PersonFriends_Persons1] FOREIGN KEY ([FriendID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[Departments] ADD CONSTRAINT [FK_Departments_Faculties] FOREIGN KEY ([FacultyID]) REFERENCES [dbo].[Faculties] ([ID])
ALTER TABLE [dbo].[TimeBoard] ADD CONSTRAINT [FK_TimeBoard_Subjects] FOREIGN KEY ([SubjectID]) REFERENCES [dbo].[Subjects] ([ID])
ALTER TABLE [dbo].[Faculties] ADD CONSTRAINT [FK_Faculties_Universities] FOREIGN KEY ([UniversityID]) REFERENCES [dbo].[Universities] ([ID])
ALTER TABLE [dbo].[Subjects] ADD CONSTRAINT [FK_Subjects_ParameterValues] FOREIGN KEY ([SubjectType]) REFERENCES [meta].[ParameterValues] ([ID])
ALTER TABLE [dbo].[TeacherFaculties] ADD CONSTRAINT [FK_TeacherFaculties_Faculties] FOREIGN KEY ([FacultyID]) REFERENCES [dbo].[Faculties] ([ID])
ALTER TABLE [dbo].[TeacherFaculties] ADD CONSTRAINT [FK_TeacherFaculties_Teachers] FOREIGN KEY ([TeacherID]) REFERENCES [dbo].[Teachers] ([ID])
ALTER TABLE [dbo].[TeacherDepartments] ADD CONSTRAINT [FK_TeacherDepartments_Departments] FOREIGN KEY ([DepartmentID]) REFERENCES [dbo].[Departments] ([ID])
ALTER TABLE [dbo].[TeacherDepartments] ADD CONSTRAINT [FK_TeacherDepartments_Teachers] FOREIGN KEY ([TeacherID]) REFERENCES [dbo].[Teachers] ([ID])
ALTER TABLE [dbo].[Groups] ADD CONSTRAINT [FK_Groups_Departments] FOREIGN KEY ([DepartmentID]) REFERENCES [dbo].[Departments] ([ID])
ALTER TABLE [dbo].[TheacherSubjects] ADD CONSTRAINT [FK_TheacherSubjects_Subjects] FOREIGN KEY ([SubjectID]) REFERENCES [dbo].[Subjects] ([ID])
ALTER TABLE [dbo].[TheacherSubjects] ADD CONSTRAINT [FK_TheacherSubjects_Teachers] FOREIGN KEY ([TeacherID]) REFERENCES [dbo].[Teachers] ([ID])
ALTER TABLE [dbo].[Teachers] ADD CONSTRAINT [FK_Teachers_Persons] FOREIGN KEY ([PersonID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [meta].[Localizations] ADD CONSTRAINT [FK_Localizations_Languages] FOREIGN KEY ([LanguageName]) REFERENCES [meta].[Languages] ([Name])
ALTER TABLE [meta].[Localizations] ADD CONSTRAINT [FK_Localizations_Resources] FOREIGN KEY ([Resource]) REFERENCES [meta].[Resources] ([Name]) ON UPDATE CASCADE
ALTER TABLE [dbo].[PersonSchedules] ADD CONSTRAINT [FK_PersonSchedules_Persons] FOREIGN KEY ([PersonID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[PersonSchedules] ADD CONSTRAINT [FK_PersonSchedules_Schedules] FOREIGN KEY ([ScheduleID]) REFERENCES [dbo].[Schedules] ([ID])
ALTER TABLE [dbo].[Students] ADD CONSTRAINT [FK_Students_Groups] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[Groups] ([ID])
ALTER TABLE [dbo].[Students] ADD CONSTRAINT [FK_Students_Persons] FOREIGN KEY ([PersonID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] ADD CONSTRAINT [FK__aspnet_Pe__PathI__37A5467C] FOREIGN KEY ([PathId]) REFERENCES [dbo].[aspnet_Paths] ([PathId])
ALTER TABLE [dbo].[Persons] ADD CONSTRAINT [FK_Persons_aspnet_Users] FOREIGN KEY ([aspnet_UserID]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[Persons] ADD CONSTRAINT [FK_Persons_ParameterValues] FOREIGN KEY ([SexID]) REFERENCES [meta].[ParameterValues] ([ID])
ALTER TABLE [meta].[ParameterValues] ADD CONSTRAINT [FK_ParameterValues_Parameters] FOREIGN KEY ([ParameterID]) REFERENCES [meta].[Parameters] ([ID])
ALTER TABLE [meta].[ParameterValues] ADD CONSTRAINT [FK_ParameterValues_Resources] FOREIGN KEY ([Value]) REFERENCES [meta].[Resources] ([Name]) ON UPDATE CASCADE
ALTER TABLE [dbo].[aspnet_Paths] ADD CONSTRAINT [FK__aspnet_Pa__Appli__36B12243] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
ALTER TABLE [dbo].[aspnet_Paths] ADD CONSTRAINT [FK__aspnet_Pa__Appli__49C3F6B7] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
ALTER TABLE [meta].[Parameters] ADD CONSTRAINT [FK_Parameters_Resources] FOREIGN KEY ([Name]) REFERENCES [meta].[Resources] ([Name]) ON UPDATE CASCADE
ALTER TABLE [dbo].[Events] ADD CONSTRAINT [FK_Classes_Persons] FOREIGN KEY ([PersonID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[Events] ADD CONSTRAINT [FK_Classes_Subjects] FOREIGN KEY ([SubjectID]) REFERENCES [dbo].[Subjects] ([ID])
ALTER TABLE [dbo].[Events] ADD CONSTRAINT [FK_Events_Builgings] FOREIGN KEY ([BuildingID]) REFERENCES [dbo].[Builgings] ([ID])
ALTER TABLE [dbo].[Events] ADD CONSTRAINT [FK_Events_EventTypes] FOREIGN KEY ([EventTypeID]) REFERENCES [dbo].[EventTypes] ([ID])
ALTER TABLE [dbo].[Events] ADD CONSTRAINT [FK_Events_Schedules] FOREIGN KEY ([ScheduleID]) REFERENCES [dbo].[Schedules] ([ID])
ALTER TABLE [dbo].[GroupSchedules] ADD CONSTRAINT [FK_GroupSchedules_Groups] FOREIGN KEY ([GroupID]) REFERENCES [dbo].[Groups] ([ID])
ALTER TABLE [dbo].[GroupSchedules] ADD CONSTRAINT [FK_GroupSchedules_Schedules] FOREIGN KEY ([ScheduleID]) REFERENCES [dbo].[Schedules] ([ID])
ALTER TABLE [dbo].[aspnet_Roles] ADD CONSTRAINT [FK__aspnet_Ro__Appli__3B75D760] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
ALTER TABLE [dbo].[aspnet_Roles] ADD CONSTRAINT [FK__aspnet_Ro__Appli__5165187F] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
ALTER TABLE [dbo].[aspnet_Profile] ADD CONSTRAINT [FK__aspnet_Pr__UserI__3A81B327] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[aspnet_Membership] ADD CONSTRAINT [FK__aspnet_Me__Appli__34C8D9D1] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
ALTER TABLE [dbo].[aspnet_Membership] ADD CONSTRAINT [FK__aspnet_Me__Appli__45F365D3] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
ALTER TABLE [dbo].[aspnet_Membership] ADD CONSTRAINT [FK__aspnet_Me__UserI__35BCFE0A] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[aspnet_Membership] ADD CONSTRAINT [FK__aspnet_Me__UserI__46E78A0C] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[aspnet_UsersInRoles] ADD CONSTRAINT [FK__aspnet_Us__RoleI__3E52440B] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[aspnet_Roles] ([RoleId])
ALTER TABLE [dbo].[aspnet_UsersInRoles] ADD CONSTRAINT [FK__aspnet_Us__RoleI__5535A963] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[aspnet_Roles] ([RoleId])
ALTER TABLE [dbo].[aspnet_UsersInRoles] ADD CONSTRAINT [FK__aspnet_Us__UserI__3D5E1FD2] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[aspnet_UsersInRoles] ADD CONSTRAINT [FK__aspnet_Us__UserI__5441852A] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[PersonMessages] ADD CONSTRAINT [FK_PersonMessages_Message] FOREIGN KEY ([MessageID]) REFERENCES [dbo].[Message] ([ID])
ALTER TABLE [dbo].[PersonMessages] ADD CONSTRAINT [FK_PersonMessages_Persons] FOREIGN KEY ([PersonID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[Message] ADD CONSTRAINT [FK_Message_Persons] FOREIGN KEY ([SenderID]) REFERENCES [dbo].[Persons] ([ID])
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD CONSTRAINT [FK__aspnet_Pe__PathI__38996AB5] FOREIGN KEY ([PathId]) REFERENCES [dbo].[aspnet_Paths] ([PathId])
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD CONSTRAINT [FK__aspnet_Pe__PathI__4CA06362] FOREIGN KEY ([PathId]) REFERENCES [dbo].[aspnet_Paths] ([PathId])
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD CONSTRAINT [FK__aspnet_Pe__UserI__398D8EEE] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] ADD CONSTRAINT [FK__aspnet_Pe__UserI__4D94879B] FOREIGN KEY ([UserId]) REFERENCES [dbo].[aspnet_Users] ([UserId])
ALTER TABLE [dbo].[aspnet_Users] ADD CONSTRAINT [FK__aspnet_Us__Appli__3C69FB99] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
COMMIT TRANSACTION
